﻿	CREATE TABLE public.resource_type
	(
	    /***************************************************************************************************
	    **  Table:	    public.resource_type
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    List of registered resource types.
	    **
	    **  Fields (3):
	    **
	    **      Id      - Defaults to nextval('resource_type_id_seq')
	    **      Name    - Required unique user-input value
	    
	    **
	    **  Constaints (2):
	    **
	    **      resource_type_pk - 
	    **      resource_type_uc - 
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    id          integer                NOT NULL DEFAULT nextval('resource_type_id_seq'), 
	    name        character varying(128) NOT NULL,
        
	    -- [Constraints]
	    CONSTRAINT resource_type_pk PRIMARY KEY (id),
	    CONSTRAINT resource_type_uc UNIQUE (name)
	);